-------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\4-ce_data_analysis.log
  log type:  text
 opened on:  21 Jan 2023, 17:18:50

. log off ;
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\4-ce_data_analysis.log
  log type:  text
 paused on:  21 Jan 2023, 17:18:50
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\4-ce_data_analysis.log
  log type:  text
resumed on:  21 Jan 2023, 17:18:50

. tab gender ;

      Q55 - |
Gender (= 1 |
   if Male) |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |      1,236       49.22       49.22
   .4191853 |         49        1.95       51.17
   .4931921 |         42        1.67       52.85
   .5080386 |         65        2.59       55.44
          1 |      1,119       44.56      100.00
------------+-----------------------------------
      Total |      2,511      100.00

. tab county ;

  County of |
  residence |
(G=Guilford |
  , W=Wake, |
M=Mecklenbu |
        rg) |      Freq.     Percent        Cum.
------------+-----------------------------------
          G |        810       32.26       32.26
          M |        703       28.00       60.25
          W |        998       39.75      100.00
------------+-----------------------------------
      Total |      2,511      100.00

. sum income, detail ;

                   Q59 - Household Income
-------------------------------------------------------------
      Percentiles      Smallest
 1%        10000          10000
 5%        10000          10000
10%        25000          10000       Obs               2,511
25%        55000          10000       Sum of Wgt.       2,511

50%        87500                      Mean           99130.84
                        Largest       Std. Dev.      61630.62
75%       137500         225000
90%       225000         225000       Variance       3.80e+09
95%       225000         225000       Skewness       .6616972
99%       225000         225000       Kurtosis          2.546

. tab covid19 ;

     Q288 - |
COVID19 had |
         no |
 effect(0), |
       less |
 likely(1), |
       more |
  likely(2) |
to vote for |
       act  |      Freq.     Percent        Cum.
------------+-----------------------------------
         -1 |        134        5.34        5.34
          0 |      1,789       71.25       76.58
          1 |        148        5.89       82.48
          2 |        440       17.52      100.00
------------+-----------------------------------
      Total |      2,511      100.00

. tab debrief_1 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 my answers |
      might |
  influence |
  design of |
     future |
   policies |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,181       49.09       49.09
          D |        144        5.99       55.07
          N |        749       31.13       86.20
         SA |        283       11.76       97.96
         SD |         49        2.04      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_2 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 believable |
    that my |
  household |
 would have |
     to pay |
    higher  |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,267       52.66       52.66
          D |         68        2.83       55.49
          N |        194        8.06       63.55
         SA |        851       35.37       98.92
         SD |         26        1.08      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_3 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
     choose |
 disagree - |
       trap |
   question |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |         74        3.08        3.08
          D |      2,184       90.77       93.85
          N |         87        3.62       97.46
         SA |         32        1.33       98.79
         SD |         29        1.21      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_4 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 considered |
   both the |
improved wq |
    and the |
costs to hh |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,253       52.08       52.08
          D |         38        1.58       53.66
          N |        122        5.07       58.73
         SA |        974       40.48       99.21
         SD |         19        0.79      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_5 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
     stream |
      water |
quality are |
 valuable / |
  something |
    WTP for |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,133       47.09       47.09
          D |        171        7.11       54.20
          N |        519       21.57       75.77
         SA |        543       22.57       98.34
         SD |         40        1.66      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_6 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
     doubts |
county govt |
    will be |
    able to |
    improve |
  stream wq |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |        726       30.17       30.17
          D |        547       22.73       52.91
          N |        822       34.16       87.07
         SA |        253       10.52       97.59
         SD |         58        2.41      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_7 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 opposed to |
     higher |
  taxes, no |
matter what |
   they are |
      used  |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |        324       13.47       13.47
          D |        964       40.07       53.53
          N |        539       22.40       75.94
         SA |        198        8.23       84.16
         SD |        381       15.84      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_8 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
provided me |
with enough |
    info to |
       make |
   informed |
     choice |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,453       60.39       60.39
          D |         94        3.91       64.30
          N |        307       12.76       77.06
         SA |        540       22.44       99.50
         SD |         12        0.50      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_9 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
  no effect |
   on other |
 streams or |
  on lake / |
   river wq |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,216       50.54       50.54
          D |         70        2.91       53.45
          N |        215        8.94       62.39
         SA |        889       36.95       99.33
         SD |         16        0.67      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_10 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
   describe |
  myself as |
         an |
environment |
      alist |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |        800       33.25       33.25
          D |        313       13.01       46.26
          N |      1,003       41.69       87.95
         SA |        221        9.19       97.13
         SD |         69        2.87      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_11 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 survey was |
objective / |
 didnt push |
 me to vote |
  for/again |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,317       54.74       54.74
          D |        102        4.24       58.98
          N |        358       14.88       73.86
         SA |        601       24.98       98.84
         SD |         28        1.16      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_9 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
  no effect |
   on other |
 streams or |
  on lake / |
   river wq |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,216       50.54       50.54
          D |         70        2.91       53.45
          N |        215        8.94       62.39
         SA |        889       36.95       99.33
         SD |         16        0.67      100.00
------------+-----------------------------------
      Total |      2,406      100.00

. tab debrief_9 if inlist(debrief_10,"SA","A") ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
  no effect |
   on other |
 streams or |
  on lake / |
   river wq |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |        486       47.60       47.60
          D |         25        2.45       50.05
          N |         53        5.19       55.24
         SA |        451       44.17       99.41
         SD |          6        0.59      100.00
------------+-----------------------------------
      Total |      1,021      100.00

. tab debrief_9 if inlist(college,1) ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
  no effect |
   on other |
 streams or |
  on lake / |
   river wq |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |        836       48.95       48.95
          D |         42        2.46       51.41
          N |        112        6.56       57.96
         SA |        708       41.45       99.41
         SD |         10        0.59      100.00
------------+-----------------------------------
      Total |      1,708      100.00

. /* MOST / LEAST IMPORTANT ATTRIBUTES BROKEN DOWN BY WHETHER ATTRIBUTES WERE PRESENTED IN FORWARD/REVERSE DIRECTION */
> /* MOST / LEAST IMPORTANT ATTRIBUTES BROKEN DOWN BY WHETHER ATTRIBUTES WERE PRESENTED IN FORWARD/REVERSE DIRECTION */
> /* MOST / LEAST IMPORTANT ATTRIBUTES BROKEN DOWN BY WHETHER ATTRIBUTES WERE PRESENTED IN FORWARD/REVERSE DIRECTION */
> 
> d block_f ;

              storage   display    value
variable name   type    format     label      variable label
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
block_f         byte    %9.0g                 Forward / reverse ordering if attributes (=1 if forward, =0 if reverse)

. /* MOST IMPORTANT ATTRIBUTE */
> /* MOST IMPORTANT ATTRIBUTE */
> /* MOST IMPORTANT ATTRIBUTE */
> 
> tab attribute_1 ;

 Q201 - 1st |
       most |
  important |
  attribute |      Freq.     Percent        Cum.
------------+-----------------------------------
         EC |      1,145       47.61       47.61
         HR |      1,197       49.77       97.38
         MD |         63        2.62      100.00
------------+-----------------------------------
      Total |      2,405      100.00

. tab attribute_1 if block_f == 1 ;

 Q201 - 1st |
       most |
  important |
  attribute |      Freq.     Percent        Cum.
------------+-----------------------------------
         EC |        564       47.20       47.20
         HR |        601       50.29       97.49
         MD |         30        2.51      100.00
------------+-----------------------------------
      Total |      1,195      100.00

. tab attribute_1 if block_f == 0 ;

 Q201 - 1st |
       most |
  important |
  attribute |      Freq.     Percent        Cum.
------------+-----------------------------------
         EC |        581       48.02       48.02
         HR |        596       49.26       97.27
         MD |         33        2.73      100.00
------------+-----------------------------------
      Total |      1,210      100.00

. /* LEAST IMPORTANT ATTRIBUTE */
> /* LEAST IMPORTANT ATTRIBUTE */
> /* LEAST IMPORTANT ATTRIBUTE */
> 
> tab attribute_3 ;

     Q201 - |
      Least |
  important |
  attribute |      Freq.     Percent        Cum.
------------+-----------------------------------
         EC |        156        6.21        6.21
         HR |        216        8.60       14.81
         MD |      2,139       85.19      100.00
------------+-----------------------------------
      Total |      2,511      100.00

. tab attribute_3 if block_f == 1  ;

     Q201 - |
      Least |
  important |
  attribute |      Freq.     Percent        Cum.
------------+-----------------------------------
         EC |         68        5.43        5.43
         HR |        107        8.55       13.98
         MD |      1,077       86.02      100.00
------------+-----------------------------------
      Total |      1,252      100.00

. tab attribute_3 if block_f == 0  ;

     Q201 - |
      Least |
  important |
  attribute |      Freq.     Percent        Cum.
------------+-----------------------------------
         EC |         88        6.99        6.99
         HR |        109        8.66       15.65
         MD |      1,062       84.35      100.00
------------+-----------------------------------
      Total |      1,259      100.00

. gen test = (ce1 == -1) | (ce2 == -1) | (ce3 == -1) | (ce4 == -1) ;

. tab test ;

       test |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |      2,437       97.05       97.05
          1 |         74        2.95      100.00
------------+-----------------------------------
      Total |      2,511      100.00

. drop test ;

. di _N ;
2511

. keep resp_id `demos' cost* ce* order* ec_g* ec_m* ec_p* hr_g* hr_m* hr_p* md_g* md_m* md_p* ;

. reshape long cost ce order ec_g ec_m ec_p hr_g hr_m hr_p md_g md_m md_p, i(resp_id) j(seq) ;
(note: j = 1 2 3 4)

Data                               wide   ->   long
-----------------------------------------------------------------------------
Number of obs.                     2511   ->   10044
Number of variables                  85   ->      50
j variable (4 values)                     ->   seq
xij variables:
                  cost1 cost2 ... cost4   ->   cost
                        ce1 ce2 ... ce4   ->   ce
               order1 order2 ... order4   ->   order
                  ec_g1 ec_g2 ... ec_g4   ->   ec_g
                  ec_m1 ec_m2 ... ec_m4   ->   ec_m
                  ec_p1 ec_p2 ... ec_p4   ->   ec_p
                  hr_g1 hr_g2 ... hr_g4   ->   hr_g
                  hr_m1 hr_m2 ... hr_m4   ->   hr_m
                  hr_p1 hr_p2 ... hr_p4   ->   hr_p
                  md_g1 md_g2 ... md_g4   ->   md_g
                  md_m1 md_m2 ... md_m4   ->   md_m
                  md_p1 md_p2 ... md_p4   ->   md_p
-----------------------------------------------------------------------------

. label var seq "CE Sequence ID (not the same as order presented - see ORDER variable)" ;

. di _N ;
10044

. drop if ce == -1 ;
(206 observations deleted)

.   di _N ;
9838

. by resp_id : gen test = _N  if _n == _N ;
(7,327 missing values generated)

. tab test ;

       test |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |         63        2.51        2.51
          2 |          6        0.24        2.75
          3 |          5        0.20        2.95
          4 |      2,437       97.05      100.00
------------+-----------------------------------
      Total |      2,511      100.00

. drop test ;

. log off ;
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\4-ce_data_analysis.log
  log type:  text
 paused on:  21 Jan 2023, 17:18:50
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\4-ce_data_analysis.log
  log type:  text
resumed on:  21 Jan 2023, 17:18:50

. tab order ;

Ordering of |
   CEs (1 = |
 First, 4 = |
      Last) |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |      2,511       25.52       25.52
          2 |      2,448       24.88       50.41
          3 |      2,442       24.82       75.23
          4 |      2,437       24.77      100.00
------------+-----------------------------------
      Total |      9,838      100.00

. tab order if county == "W" ;

Ordering of |
   CEs (1 = |
 First, 4 = |
      Last) |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        998       25.59       25.59
          2 |        969       24.85       50.44
          3 |        967       24.79       75.23
          4 |        966       24.77      100.00
------------+-----------------------------------
      Total |      3,900      100.00

. tab order if county == "M" ;

Ordering of |
   CEs (1 = |
 First, 4 = |
      Last) |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        703       25.58       25.58
          2 |        684       24.89       50.47
          3 |        681       24.78       75.25
          4 |        680       24.75      100.00
------------+-----------------------------------
      Total |      2,748      100.00

. tab order if county == "G" ;

Ordering of |
   CEs (1 = |
 First, 4 = |
      Last) |      Freq.     Percent        Cum.
------------+-----------------------------------
          1 |        810       25.39       25.39
          2 |        795       24.92       50.31
          3 |        794       24.89       75.20
          4 |        791       24.80      100.00
------------+-----------------------------------
      Total |      3,190      100.00

. tab ce cost ;

    Action |
 Plan Vote |
 (1 = Yes, |              Action Plan Cost
   0 = No) |         4          9         18         32 |     Total
-----------+--------------------------------------------+----------
         0 |       520        703      1,085      2,311 |     4,619 
         1 |     1,688      1,257      1,142      1,132 |     5,219 
-----------+--------------------------------------------+----------
     Total |     2,208      1,960      2,227      3,443 |     9,838 

. tab ce cost if order == 1 ;

    Action |
 Plan Vote |
 (1 = Yes, |              Action Plan Cost
   0 = No) |         4          9         18         32 |     Total
-----------+--------------------------------------------+----------
         0 |       147        179        252        493 |     1,071 
         1 |       423        323        308        386 |     1,440 
-----------+--------------------------------------------+----------
     Total |       570        502        560        879 |     2,511 

. tab ce cost if order == 2 ;

    Action |
 Plan Vote |
 (1 = Yes, |              Action Plan Cost
   0 = No) |         4          9         18         32 |     Total
-----------+--------------------------------------------+----------
         0 |       109        180        270        569 |     1,128 
         1 |       418        307        307        288 |     1,320 
-----------+--------------------------------------------+----------
     Total |       527        487        577        857 |     2,448 

. tab ce cost if order == 3 ;

    Action |
 Plan Vote |
 (1 = Yes, |              Action Plan Cost
   0 = No) |         4          9         18         32 |     Total
-----------+--------------------------------------------+----------
         0 |       135        168        286        598 |     1,187 
         1 |       421        331        274        229 |     1,255 
-----------+--------------------------------------------+----------
     Total |       556        499        560        827 |     2,442 

. tab ce cost if order == 4 ;

    Action |
 Plan Vote |
 (1 = Yes, |              Action Plan Cost
   0 = No) |         4          9         18         32 |     Total
-----------+--------------------------------------------+----------
         0 |       129        176        277        651 |     1,233 
         1 |       426        296        253        229 |     1,204 
-----------+--------------------------------------------+----------
     Total |       555        472        530        880 |     2,437 

. /* PERCENT OF PEOPLE WHO SAY YES */
> /* PERCENT OF PEOPLE WHO SAY YES */
> /* PERCENT OF PEOPLE WHO SAY YES */
> 
> by cost: sum ce ;

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 4

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |      2,208    .7644928    .4244115          0          1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 9

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |      1,960    .6413265    .4797335          0          1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 18

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |      2,227    .5127975    .4999485          0          1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 32

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |      3,443     .328783    .4698392          0          1


. /* QUESTION #1 */
> /* QUESTION #1 */
> /* QUESTION #1 */
> by cost: sum ce if order == 1 ;

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 4

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        570    .7421053      .43786          0          1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 9

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        502    .6434263    .4794652          0          1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 18

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        560         .55    .4979385          0          1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 32

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        879    .4391354    .4965642          0          1


. /* QUESTION #2 */
> /* QUESTION #2 */
> /* QUESTION #2 */
> by cost: sum ce if order == 2 ;

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 4

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        527    .7931689    .4054182          0          1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 9

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        487    .6303901    .4831954          0          1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 18

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        577    .5320624    .4994039          0          1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 32

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        857     .336056    .4726341          0          1


. /* QUESTION #3 */
> /* QUESTION #3 */
> /* QUESTION #3 */
> by cost: sum ce if order == 3 ;

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 4

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        556    .7571942    .4291648          0          1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 9

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        499    .6633267    .4730463          0          1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 18

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        560    .4892857    .5003321          0          1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 32

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        827    .2769045    .4477396          0          1


. /* QUESTION #4 */
> /* QUESTION #4 */
> /* QUESTION #4 */
> by cost: sum ce if order == 4 ;

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 4

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        555    .7675676    .4227643          0          1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 9

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        472    .6271186     .484084          0          1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 18

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        530    .4773585     .499959          0          1

-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-> cost = 32

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
          ce |        880    .2602273     .439008          0          1


. /* FIRST CE, ATTRIBUTES IN FORWARD ORDER */
> /* FIRST CE, ATTRIBUTES IN FORWARD ORDER */
> /* FIRST CE, ATTRIBUTES IN FORWARD ORDER */
> 
> d block_f ;

              storage   display    value
variable name   type    format     label      variable label
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
block_f         byte    %9.0g                 Forward / reverse ordering if attributes (=1 if forward, =0 if reverse)

. sum block_f ;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     block_f |      9,838    .4979671    .5000213          0          1

. preserve ;

.   sort resp_id ;

.   by resp_id : keep if _n == 1 ;
(7,327 observations deleted)

.   tab block_f ;

  Forward / |
    reverse |
ordering if |
 attributes |
     (=1 if |
forward, =0 |
if reverse) |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |      1,259       50.14       50.14
          1 |      1,252       49.86      100.00
------------+-----------------------------------
      Total |      2,511      100.00

. restore ;

. /* ACCESS MODE (=1 IF COMPUTER/TABLET) */
> d access_mode ;

              storage   display    value
variable name   type    format     label      variable label
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
access_mode     byte    %9.0g                 Survey Accessed via Computer/tablet(= 1) or phone(= 0)

. tab access_mode if order == 1 ;

     Survey |
   Accessed |
        via |
Computer/ta |
  blet(= 1) |
 or phone(= |
         0) |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |        681       27.12       27.12
          1 |      1,830       72.88      100.00
------------+-----------------------------------
      Total |      2,511      100.00

. tab access_mode if county == "W" & order == 1 ;

     Survey |
   Accessed |
        via |
Computer/ta |
  blet(= 1) |
 or phone(= |
         0) |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |        244       24.45       24.45
          1 |        754       75.55      100.00
------------+-----------------------------------
      Total |        998      100.00

. tab access_mode if county == "M" & order == 1 ;

     Survey |
   Accessed |
        via |
Computer/ta |
  blet(= 1) |
 or phone(= |
         0) |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |        196       27.88       27.88
          1 |        507       72.12      100.00
------------+-----------------------------------
      Total |        703      100.00

. tab access_mode if county == "G" & order == 1 ;

     Survey |
   Accessed |
        via |
Computer/ta |
  blet(= 1) |
 or phone(= |
         0) |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |        241       29.75       29.75
          1 |        569       70.25      100.00
------------+-----------------------------------
      Total |        810      100.00

. save $ce_data, replace ;
file data\ce_data.dta saved

. preserve ;

.   sort resp_id ;

.   by resp_id : keep if _n == 1 ;
(7,327 observations deleted)

.   sum survey_duration, detail ;

                  Survey duration (minutes)
-------------------------------------------------------------
      Percentiles      Smallest
 1%     6.066667       3.566667
 5%     8.783334       3.816667
10%         10.6           3.95       Obs               2,511
25%     13.98333            4.2       Sum of Wgt.       2,511

50%     20.01667                      Mean           121.2554
                        Largest       Std. Dev.      884.0972
75%     30.23333       11784.95
90%     50.01667       12218.85       Variance       781627.8
95%        81.55       15630.22       Skewness       13.25568
99%     2965.467          19989       Kurtosis       213.0911

.   tab debrief_3 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
     choose |
 disagree - |
       trap |
   question |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |         74        3.08        3.08
          D |      2,184       90.77       93.85
          N |         87        3.62       97.46
         SA |         32        1.33       98.79
         SD |         29        1.21      100.00
------------+-----------------------------------
      Total |      2,406      100.00

.   tab debrief_1 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 my answers |
      might |
  influence |
  design of |
     future |
   policies |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,181       49.09       49.09
          D |        144        5.99       55.07
          N |        749       31.13       86.20
         SA |        283       11.76       97.96
         SD |         49        2.04      100.00
------------+-----------------------------------
      Total |      2,406      100.00

.   tab debrief_2 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 believable |
    that my |
  household |
 would have |
     to pay |
    higher  |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      1,267       52.66       52.66
          D |         68        2.83       55.49
          N |        194        8.06       63.55
         SA |        851       35.37       98.92
         SD |         26        1.08      100.00
------------+-----------------------------------
      Total |      2,406      100.00

.   sum resp_id ;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     resp_id |      2,511        1256    725.0076          1       2511

.  local obs = r(N) ;

.   sum resp_id if !(survey_duration >= 8 & survey_duration <= (7*24*60)) ;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     resp_id |         96    1481.271    761.1985         13       2507

.  di (100*r(N)/`obs') ;
3.823178

.   sum resp_id if !(inlist(debrief_3,"D")) ;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     resp_id |        327    1251.749    748.0409          1       2510

.  di (100*r(N)/`obs') ;
13.0227

.   sum resp_id if !(!inlist(debrief_1,"D","SD")+!inlist(debrief_2,"D","SD")) ;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     resp_id |         23    1408.391    732.3579         78       2460

.  di (100*r(N)/`obs') ;
.91596973

. restore ;

. d block_f ;

              storage   display    value
variable name   type    format     label      variable label
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
block_f         byte    %9.0g                 Forward / reverse ordering if attributes (=1 if forward, =0 if reverse)

. sum block_f ;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     block_f |      9,838    .4979671    .5000213          0          1

. preserve ;

.   keep if survey_duration >= 8 & survey_duration <= (7*24*60) & inlist(debrief_3,"D") & !inlist(debrief_1,"D","SD") & !inlist(debrief_2,"D","SD") ;
(2,254 observations deleted)

.   sort resp_id ;

.   by resp_id : keep if _n == 1 ;
(5,688 observations deleted)

.   tab block_f ;

  Forward / |
    reverse |
ordering if |
 attributes |
     (=1 if |
forward, =0 |
if reverse) |      Freq.     Percent        Cum.
------------+-----------------------------------
          0 |        937       49.42       49.42
          1 |        959       50.58      100.00
------------+-----------------------------------
      Total |      1,896      100.00

. restore ;

. sum survey_duration, detail ;

                  Survey duration (minutes)
-------------------------------------------------------------
      Percentiles      Smallest
 1%     6.183333       3.566667
 5%     9.066667       3.566667
10%     10.66667       3.566667       Obs               9,838
25%     14.13333       3.566667       Sum of Wgt.       9,838

50%       20.075                      Mean           120.1987
                        Largest       Std. Dev.      886.5874
75%     30.16667          19989
90%     49.86666          19989       Variance       786037.2
95%         81.1          19989       Skewness       13.33985
99%     2965.467          19989       Kurtosis       214.6129

. tab debrief_3 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
     choose |
 disagree - |
       trap |
   question |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |        296        3.08        3.08
          D |      8,736       90.77       93.85
          N |        348        3.62       97.46
         SA |        128        1.33       98.79
         SD |        116        1.21      100.00
------------+-----------------------------------
      Total |      9,624      100.00

. tab debrief_1 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 my answers |
      might |
  influence |
  design of |
     future |
   policies |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      4,724       49.09       49.09
          D |        576        5.99       55.07
          N |      2,996       31.13       86.20
         SA |      1,132       11.76       97.96
         SD |        196        2.04      100.00
------------+-----------------------------------
      Total |      9,624      100.00

. tab debrief_2 ;

Q52/Q202/Q2 |
       03 - |
  Debrief - |
 believable |
    that my |
  household |
 would have |
     to pay |
    higher  |      Freq.     Percent        Cum.
------------+-----------------------------------
          A |      5,068       52.66       52.66
          D |        272        2.83       55.49
          N |        776        8.06       63.55
         SA |      3,404       35.37       98.92
         SD |        104        1.08      100.00
------------+-----------------------------------
      Total |      9,624      100.00

. /* DROPPING:                                                                            */
> /*    1) SPEEDING PEOPLE (<=8 MINUTES TO COMPLETE SURVEY)                               */
> /*    2) PEOPLE WHO TAKE MORE THAN A WEEK TO COMPLETE THE SURVEY                        */
> /*    3) PEOPLE WHO FAIL THE TRAP QUESTION                                              */
> /*    4) PEOPLE WHO DISAGREE OR STRONGLY DISAGREE WITH THE CONSEQUENTIALITY STATEMENTS  */
> 
> keep if survey_duration >= 8 & survey_duration <= (7*24*60) & inlist(debrief_3,"D") & !inlist(debrief_1,"D","SD") & !inlist(debrief_2,"D","SD") ;
(2,254 observations deleted)

. sort resp_id seq ;

. by resp_id : assert wgt_final[1] == wgt_final ;

. gen double inv_dist = (1/near_dist) ;

. gen cost_dis = cost/(1+near_dist) ;

. log off ;
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\4-ce_data_analysis.log
  log type:  text
 paused on:  21 Jan 2023, 17:18:51
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\4-ce_data_analysis.log
  log type:  text
resumed on:  21 Jan 2023, 17:18:51

. d ;

Contains data from data\ce_data.dta
  obs:         7,584                          
 vars:            37                          21 Jan 2023 17:18
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
              storage   display    value
variable name   type    format     label      variable label
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
resp_id         int     %9.0g                 Respondent ID
seq             byte    %10.0g                CE Sequence ID (not the same as order presented - see ORDER variable)
ce_cnt          float   %9.0g                 # of choice occasions
nonpart         float   %9.0g                 = 1 if serial nonparticipant
block_f         byte    %9.0g                 Forward / reverse ordering if attributes (=1 if forward, =0 if reverse)
gender          float   %9.0g                 Q55 - Gender (= 1 if Male)
age             float   %9.0g                 Q56 - Age
income          float   %9.0g                 Q59 - Household Income
employ_status   byte    %9.0g                 Q710 - Employment status (1=ft,2=pt,3=un,4=ret,5=home,6=stu,7=disable,8=other)
own_rent        byte    %9.0g                 Q61 - 1 if own main residence, 2 if rent, 3 if other
water_bill      float   %9.0g                 = 1 if respondent directly pays water bill
educ            byte    %10.0g                Q60 - Education (0=none,1=some<12,2=hs dipl,3=some coll,4=AB,5=BA/BS,6=grad/prof
college         float   %9.0g                 = 1 if respondent has a 4-year college degree
adults          float   %9.0g                 Q69 - Adults >= 18
kids            float   %9.0g                 Q70 - Kids < 18
resident        byte    %9.0g                 Q48 - Years as county resident (1 = < 1 yr, 2 = 1/2, 3 = 3/5, 4 = 6/10, 5 = 10+)
native          float   %9.0g                 Q64 - 1 if American Indian or Alaska Native
asian           float   %9.0g                 Q64 - 1 if Asian
black           float   %9.0g                 Q64 - 1 if Black or African American
white           float   %9.0g                 Q64 - 1 if White
other           float   %9.0g                 Q64 - 1 if Other
hisp_latino     float   %9.0g                 Q63 - 1 if Hispanic, Latino or Spanish origin
phone           byte    %9.0g                 Q84 = 1 if survey accessed thru phone
cost            byte    %8.0g                 Action Plan Cost
ce              byte    %9.0g                 Action Plan Vote (1 = Yes, 0 = No)
order           byte    %9.0g                 Ordering of CEs (1 = First, 4 = Last)
ec_g            byte    %8.0g                 Ecosystem Conditions = % Good w/ Action Plan
ec_m            byte    %9.0g                 Ecosystem Conditions = % Fair w/ Action Plan
ec_p            byte    %8.0g                 Ecosystem Conditions = % Poor w/ Action Plan
hr_g            byte    %8.0g                 Health Risk = % Good w/ Action Plan
hr_m            byte    %9.0g                 Health Risk = % Fair w/ Action Plan
hr_p            byte    %8.0g                 Health Risk = % Poor w/ Action Plan
md_g            byte    %8.0g                 Murky Water Days = % Good w/ Action Plan
md_m            byte    %9.0g                 Murky Water Days = % Fair w/ Action Plan
md_p            byte    %8.0g                 Murky Water Days = % Poor w/ Action Plan
near_dist       double  %10.0g                Distance to Impacted Creeks
wgt_final       double  %10.0g                Final sampling weights
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sorted by: resp_id  seq
     Note: Dataset has changed since last saved.

. sum ;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     resp_id |      7,584    1266.371    719.7683          2       2511
         seq |      7,584         2.5    1.118108          1          4
      ce_cnt |      7,584           4           0          4          4
     nonpart |      7,584    .1360759    .3428918          0          1
     block_f |      7,584    .5058017    .4999993          0          1
-------------+---------------------------------------------------------
      gender |      7,584    .4641303    .4951871          0          1
         age |      7,584    51.10127    16.32762         18         90
      income |      7,584    102132.7    62456.07      10000     225000
employ_sta~s |      7,584    2.263186    1.820317         -1          8
    own_rent |      7,584    1.220992    .5358834         -1          3
-------------+---------------------------------------------------------
  water_bill |      7,584    .8605204      .34423          0          1
        educ |      7,584    4.779536    1.374941         -1          6
     college |      7,584    .7480163    .4312251          0          1
      adults |      7,584    1.978374    .8746019          1          7
        kids |      7,584    .5773636    1.011149          0         10
-------------+---------------------------------------------------------
    resident |      7,584    4.310127    1.220002         -1          5
      native |      7,584    .0129897    .1117882          0          1
       asian |      7,584    .0490134    .2136693          0          1
       black |      7,584    .1471965    .3505078          0          1
       white |      7,584    .7675108    .4179231          0          1
-------------+---------------------------------------------------------
       other |      7,584     .056775    .2286025          0          1
 hisp_latino |      7,584    .0464167    .2079986          0          1
       phone |      7,584    .2136076    .4098799          0          1
        cost |      7,584     17.9822    11.35942          4         32
          ce |      7,584     .556039    .4968825          0          1
-------------+---------------------------------------------------------
       order |      7,584         2.5    1.118108          1          4
        ec_g |      7,584    12.17181    9.325471          2         24
        ec_m |      7,584   -.5700158    12.30478        -22         22
        ec_p |      7,584   -11.60179    9.263199        -24         -2
        hr_g |      7,584    13.68091    10.62504          2         27
-------------+---------------------------------------------------------
        hr_m |      7,584   -7.554061    11.04007        -25          9
        hr_p |      7,584   -6.126846    3.759554        -11         -2
        md_g |      7,584    16.16851    13.12621          2         33
        md_m |      7,584   -4.694093    14.76512        -30         19
        md_p |      7,584   -11.47442    7.662685        -21         -3
-------------+---------------------------------------------------------
   near_dist |      7,584    9.535896    4.666071   .2335068   22.94525
   wgt_final |      7,584    810.1956    678.6608   121.8936   4186.794

. log off ;
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\4-ce_data_analysis.log
  log type:  text
 paused on:  21 Jan 2023, 17:18:51
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\4-ce_data_analysis.log
  log type:  text
resumed on:  21 Jan 2023, 17:18:51

. d ;

Contains data from data\ce_data.dta
  obs:         1,896                          
 vars:             4                          21 Jan 2023 17:18
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
              storage   display    value
variable name   type    format     label      variable label
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
resp_id         int     %9.0g                 Respondent ID
ce_cnt          float   %9.0g                 # of choice occasions
nonpart         float   %9.0g                 = 1 if serial nonparticipant
wgt_final       double  %10.0g                Final sampling weights
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sorted by: resp_id
     Note: Dataset has changed since last saved.

. sum ;

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
     resp_id |      1,896    1266.371    719.9107          2       2511
      ce_cnt |      1,896           4           0          4          4
     nonpart |      1,896    .1360759    .3429597          0          1
   wgt_final |      1,896    810.1956    678.7951   121.8936   4186.794

. log off ;
      name:  <unnamed>
       log:  C:\Users\rhhaefen\Dropbox\EPA_WQ_Grant_Survey_Files\Final_Data_Public\log\4-ce_data_analysis.log
  log type:  text
 paused on:  21 Jan 2023, 17:18:51
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
